This query joins two business objects to extract the registrants for a specified event. At runtime, the user supplies the event code.
1. Browse to IQA and browse to the folder in which you want to store a new query.
2. Select New> Query.
3. On the Summary tab, enter a Name and (optional) Description for the query.
4. Select the Sources tab and define the relation:
□ Click Add Source.
□ Browse to the Common folder containing business objects.
□ Select CsContact and CsEventHistory by pressing Ctrl to multi-select and click OK.
□ In the Relations area of the Sources tab, make sure the default relation is CSContact.iMIS Id Equals CsEventHistory.Id.
5. Define the filtering rules:
□ Select the Filters tab.
□ Mode: Advanced
□ Filter on csEventHistory.Event Code.
□ Comparison: Equal
□ Select Optional or Required from the Prompt drop-down list and enter a prompt in the field located next to the field, for example, Event Code.
□ Click the + icon to add the filter.
6. Select the Display tab to define the columns to display in the output:
□ Select the following columns: CsContact.iMIS Id, CsContact.Full Name, CsContact.Company, and CsEventHistory.Event.
Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.
□ Click Refresh.
□ Using the Order drop-down list, assign:
■ CsContact.iMIS Id Order 1
■ CsEventHistory.Event Order 2.
7. Specify the sorting priority:
□ Select the Sorting tab.
□ Sort the results by CsEventHistory.Event.
□ Click the + icon to add the selection.
8. Save your settings.
9. Run the query.
Tips
If you want to show current registrants of open events, link to csRegistration instead of csEventHistory and set the default relation as CsContact.iMIS ID Equals csRegistration.Ship To ID.
The primary difference between Cs and non-Cs objects is that the the non-Cs objects contain the .NET security in them, but Cs Objects are basically just views pointing to the underlying non-.NET tables. When you use a non-Cs object, you may notice additional fields like Access Key and Contact Key. These fields are important when you are linking to objects with security, such as a Campaign business object where a user must have certain security to be able to view data.